Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReasonCode (PK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | |
ReasonCodeGroupCode (FK) | A retailer assigned code denoting the family of related reason codes for classifying data and actions within the systems of the retail enterprise. | CD_RSN_GRP | Code | varchar(20) | ReasonCodeGroup(CO_CD_RSN_GRP) |
ReasonName | The display name that matches the retailer assigned reason code. | NM_RSN | Name | varchar(40) | |
ReasonDescription | A narrative description describing the uses of the retailer assigned reason code. | DE_RC | DescriptionNarrative | varchar(4000) | |